{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction and guidance","Flock input details","Diet input details","Results","References and assumptions log","Calculations - Data tables","Calculations - Dataset"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction and guidance","index":0,"n_rows":79,"n_cols":33,"rows_kept":79,"cut":false,"hidden":false,"merged":[[41,2,42,12],[41,13,42,15],[43,2,63,14],[36,2,37,14],[34,2,34,4],[35,2,35,14],[38,2,38,14],[39,2,39,14],[40,2,40,3],[40,4,40,6],[40,7,40,9],[40,10,40,12],[9,2,12,14],[33,5,33,6],[34,5,34,6],[33,11,33,14],[34,11,34,14],[33,7,33,10],[34,7,34,10],[16,2,17,14],[14,2,15,14],[18,2,31,14],[32,2,32,14],[33,2,33,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Broiler excreta mass balance model"]
[]
[]
[]
[]
[null,null,"Nutritional Management Best Available Techniques for Poultry\n(click here to see regulations)"]
[]
[null,null,"Best Available Techniques (BAT) Reference Document for the Intensive Rearing of Poultry or Pigs \n(click here to see reference document)"]
[]
[null,null,"\nIntroduction:\n\nFarms with more than 40,000 rearing places for poultry fall in scope of regulations requiring the adoption of Best Available Techniques (BAT) to reduce environmental emissions. BAT for pig and poultry farms is outlined in a published BAT Conclusions (BATC) document (see link above). BAT 3 requires farms to reduce total nitrogen excreted whilst BAT 4 requires  the reduction of total phosphorus excreted.  The  BATC include levels for total nitrogen and total phosphorus excreted, measured per animal place. All permitted farms must meet these levels.  \n\nBAT 24 requires the monitoring of total nitrogen and total phosphorus excreted with two recognised methods: Calculation by using a mass balance or estimation using manure analysis results.  Issued permits contain conditions requiring submission of the derived data on an annual basis.  \n\nThis simple spreadsheet tool has been designed to assist farms in assessing compliance with the new BAT for poultry and follows a mass balance calculation approach. The tool is recognised by the Environment Agency, Natural Resources Wales, Northern Ireland Environment Agency and Scottish Environment Protection Agency.\n\nInstructions:\n\nTo calculate the BAT Emission levels please follow the instructions embedded within each worksheet.  Details of the Flock and Diets need entering in the ‘Flock Input Details’ and ‘Diet Input Details’ worksheets, the emission values and feed intake data will then be calculated in the  ‘Results’ worksheet.  Only when all values are completed within the input forms will the BAT values be calculated. \n\nInputs need to accurately reflect your system usage across the year. You should save a copy of your completed calculator tool in case it is requested as part of future permit compliance checks.\n\nYou will need to read the terms of use below and tick the agree box before you can use the tool.  \n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"BAT Total Nitrogen and Phosphorus Excreted Levels"]
[null,null,"Parameter",null,null,"Category",null,"BAT-associated total nitrogen excreted ⁽¹⁾⁽²⁾ \n(kg N excreted/animal place/year)",null,null,null,"BAT-associated total phosphorus excreted ⁽¹⁾⁽²⁾  \n(kg P₂O₅ excreted/animal place/year)"]
[null,null,"Total nutrient excreted ",null,null,"Broilers",null,"0.2 - 0.6",null,null,null,"0.05 - 0.25"]
[null,null,"(1) The lower end of the range can be achieved by using a combination of techniques. \n(2) The BAT-associated total nitrogen/phosphorus excreted is not applicable to pullets or breeders, for all poultry species. \nThe associated monitoring is in BAT 24. The BAT-associated total phosphorus or nitrogen excreted levels may not be applicable to organic livestock production nor to the rearing of poultry species not indicated above."]
[null,null,"Acknowledgements:\n\nThis simple spreadsheet tool has been designed, based on an update of the previous model (created by AIC), by Ricardo. This work model has been developed on behalf of the Environment Agency alongside a partnership of industry bodies (BPC, BEIC) to assist farms in assessing compliance with the new BAT for poultry. The tool has been peer reviewed by experts in feed nutrition and is recognised by the Environment Agency, Natural Resources Wales, Northern Ireland Environment Agency and Scottish Environment Protection Agency.\n"]
[]
[null,null,"Terms of use"]
[null,null,"Enter your installation name and permit reference number in the white boxes below:"]
[null,null,"Installation Name:",null,null,null,null,"Permit Number:"]
[null,null,"To use the calculator, first read the terms of use below and tick the box to confirm your acceptance \n(the calculator will not work if this box is not ticked)",null,null,null,null,null,null,null,null,null,null,"Tick to confirm\nacceptance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Terms of use\n\nIn making use of the BAT Emission Calculator (“the Calculator”), I agree to and accept the following:\n1. I understand that the Calculator has been made available to me by the PARTNERS (Environment Agency, BPC, BEIC) (“the Partners”), and that whilst the Partners have used their best endeavours to ensure the accuracy of the Calculator, the Partners accept no liability or responsibility whatsoever for any errors or omissions in the Calculator.\n2. I understand that, so far as is permitted in law, the Partners accept no liability or responsibility whatsoever for any losses, financial penalties or other consequential losses howsoever arising from my use of the Calculator.\n3. It is my responsibility to ensure that the data that I input into the Calculator is accurate and correct.\n4. I accept that the Partners and their employees and agents do not have sufficient knowledge of my individual farm or business to provide advice as to my individual requirements.\n5. I understand that the Calculator is no substitute for professional advice and that I should seek professional advice as to my compliance requirements under any relevant legislation.\n6. I agree that it is my responsibility to ensure that I comply with the relevant compliance requirements under any relevant legislation.\n7. I agree that English law applies to my use of the Calculator, and the Courts of England and Wales have jurisdiction to hear any disputes arising from my use of the Calculator.\n8. I agree that if I am using the Calculator in a professional capacity for the benefit of a client, it is my responsibility as my client’s professional adviser to advise my client on his / her compliance with the relevant requirements under any relevant legislation."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Please note: If further details on the data inputs and calculations are required, calculation sheets can be unlocked within the model by right clicking the 'Introduction and guidance' tab, clicking 'Unhide...' highlighting each sheet and clicking 'OK'."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]

{"sheet":"Flock input details","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,6,20,12],[22,6,24,12],[3,1,3,2],[9,3,9,4]]}
[null,null,null,null,"Input data - flock details"]
[]
[null,"Flock input table 1:",null,null,null,null,"\nFlock details input instructions\n \nPlease note: One complete workbook needs to be filled out per management system on your farm.  \n\nFlock input table 1:\nEnter number of birds per cycle and number of days between the final clearance and the next cycle in the two white boxes. Note this should reflect the number of birds per cycle not the total annual number of birds. The number of birds per cycle entry cell will go red if the value entered is below 40,000 rearing places, the BAT regulation limit. If you have under 40,000 birds you can still use this tool as normal.\nNote: Number of cycles will not calculate correctly until Flock input table 2 is completed.\n\nFlock input table 2:\nEnter the age of thin(s) to the flock in days and the percentage of birds taken each time in the white boxes. Note, the percentage of thins and clear should total 100%.\n\nFlock input table 3:\nEnter a FCR value.  The target value is the average from the performance data.  The difference between these will be calculated and used to update the performance data.  If the FCR value is not known, this can be left blank and the target value will be used.\nEnter a value for the bodyweight at clear.  The target value is from the performance data.  The difference between these will be calculated and used to adjust the performance data. \n\nFlock input table 4:\nEnter a percentage value for 7 day mortality in the white box."]
[null,"Per Shed/Farm"]
[null,"Number of birds per cycle"]
[null,"Days empty between cycles"]
[null,"Number of cycles per year",{"$f":"IF(C6=\"\",\"\",(365/(C13+C6)))","v":""}]
[]
[null,"Flock input table 2: "]
[null,"Flock Program Summary","Days","Thinning percentage"]
[null,"Age of 1st thin",null,"% 1st thin"]
[null,"Age of 2nd thin",null,"% 2nd thin"]
[null,"Age of clear",null,"% clear"]
[null,null,null,null,{"$f":"SUM(E11:E13)","v":0}]
[]
[null,"Flock input table 3:"]
[null,"Modelling Factors","Your Values","Target Values"]
[null,"FCR",null,{"$f":"AVERAGE(Table2[FCR])","v":1.2402678571428574}]
[null,"Bodyweight (g)",null,{"$f":"VLOOKUP(C13,Perf_Data,2)","v":0}]
[]
[null,"Flock input table 4:"]
[null,"Other Factors"]
[null,"7 day mortality (% of flock)",null,null,null,null,"Performance data available, click here."]

{"sheet":"Diet input details","index":2,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,7,27,11],[31,1,31,3],[3,1,3,5],[17,1,17,5],[30,1,30,4],[4,1,4,2],[14,1,14,2],[18,1,18,2]]}
[null,null,null,null,"Input data - diet details"]
[]
[null,"Diet input table 1:"]
[null,"Diet Details",null,null,null,null,null,"\nFlock details input instructions\n\nDiet input table 1:\nPlease input protein and phosphorus levels (values can be found on all feed declaration tickets) for the appropriate diets in the white boxes in the \"Diet Details\" table.\nIf the diets are the same (e.g. Grower 1 and 2), then please put the same protein and phosphorus values in both respective sets of boxes.\nIf feed diet groups are not used then leave the cells blank and move on to the next used group.\nEditable entry cells can be used to add a description/name to the feed rations you use. There is a separate row for composition of Whole Wheat. If Whole Wheat is not fed these cells can be left blank.\n\nDiet input table 2:\nEnter the start and end days within the production cycle for each diet including the proportion (percentage of total ration fed) of the diet that is made up using Whole Wheat in the final column.\nPlease note the Feed Start Day should be one higher than the previous ration Feed End Day.\nThe final Feed End Day should be less than or equal to the day of clear, found on Flock Input Details page.\n\nDiet input table 3:\nState the level of phytase used within the diet. This is a drop down box with predefined additive values, please select the value closest to your phytase addition to feed."]
[null,"Diet",null,"Crude Protein (%)","Total Nitrogen (%)","Total Phosphorus (%)"]
[null,"Ration 1","Editable entry cell",null,{"$f":"D6/6.25","v":0}]
[null,"Ration 2","Editable entry cell",null,{"$f":"D7/6.25","v":0}]
[null,"Ration 3","Editable entry cell",null,0]
[null,"Ration 4","Editable entry cell",null,0]
[null,"Ration 5","Editable entry cell",null,0]
[null,"Ration 6","Editable entry cell",null,0]
[null,"Ration 7","Editable entry cell",null,0]
[null,"Ration 8","Editable entry cell",null,0]
[null,"Ration 9","Editable entry cell",null,{"$f":"D14/6.25","v":0}]
[null,"Whole Wheat",null,null,{"$f":"D15/6.25","v":0}]
[]
[null,"Diet input table 2:"]
[null,"Feed Plan Details"]
[null,"Diet",null,"Feed Start (Day)","Feed End (Day)","Whole Wheat (% of ration)"]
[null,{"$f":"B6","v":"Ration 1"},{"$f":"IF(C6=\"Editable entry cell\",\"\",IF(C6=\"\",\"\",C6))","v":""}]
[null,{"$f":"B7","v":"Ration 2"},{"$f":"IF(C7=\"Editable entry cell\",\"\",IF(C7=\"\",\"\",C7))","v":""}]
[null,"Ration 3",{"$f":"IF(C8=\"Editable entry cell\",\"\",IF(C8=\"\",\"\",C8))","v":""}]
[null,"Ration 4",""]
[null,"Ration 5",""]
[null,"Ration 6",""]
[null,"Ration 7",""]
[null,"Ration 8",""]
[null,"Ration 9",""]
[]
[null,"Diet input table 3:"]
[null,"Nutrient Retention"]
[null,"Phytase feed additive value",null,null,"None"]

{"sheet":"Results","index":3,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,5,23,7],[24,5,24,7],[25,5,25,7],[11,1,11,3],[10,1,10,7],[11,4,11,7],[23,2,23,3],[24,2,24,3],[25,2,25,3],[22,2,22,7],[6,12,18,16],[14,2,14,4],[14,7,14,8],[3,7,3,8],[3,9,3,10],[3,1,3,2],[3,3,3,4],[7,1,7,3],[8,1,8,3],[6,1,6,7],[7,4,7,7],[8,4,8,7]]}
[null,null,null,null,null,null,"Export data - emission levels"]
[]
[]
[null,"Installation name:",null,{"$f":"'Introduction and guidance'!E41","v":0},null,null,null,"Permit Number:",null,{"$f":"'Introduction and guidance'!K41","v":0}]
[]
[]
[null,"BAT Emission Level",null,null,null,null,null,null,null,null,null,null,"\nResults sheet instructions\n\nUse the data given in this box to demonstrate compliance with the nitrogen and phosphorus excretion levels.\n\nBased on the data entered within the diet and flock details input the emission levels are calculated within the BAT Emission level box, and colour coded green to show compliance with the upper limits of the BAT standards. If the cells turn red then the emission levels are not compliant.\n\n   -  Nitrogen upper limit = 0.6kg N/animal/place/year\n   -  Phosphorus upper limit = 0.25kg P/animal place/year \n\n\n"]
[null,"Nitrogen excreted\nPer animal place (kg N/ Year)",null,null,"Phosphorus excreted\nPer animal place (kg P/ Year)"]
[null,{"$f":"H20","v":{"$error":"#VALUE!"}},null,null,{"$f":"I20","v":{"$error":"#VALUE!"}}]
[]
[null,"Percentage of BAT upper Limit"]
[null,{"$f":"B9/0.6","v":{"$error":"#VALUE!"}},null,null,{"$f":"E9/0.25","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Intake Data",null,null,null,null,"Emission Data"]
[null,null,"Cumulative feed intake (t)","Nitrogen intake (t)","Phosphorus intake (t)",null,null,"Nitrogen excreted (t)","Phosphorus excreted (t)"]
[null,"Per cycle",{"$f":"'Calculations - Dataset'!B130","v":0},{"$f":"'Calculations - Dataset'!C130","v":0},{"$f":"'Calculations - Dataset'!D130","v":0},null,"Per cycle",{"$f":"'Calculations - Dataset'!E130","v":0},{"$f":"'Calculations - Dataset'!F130","v":0}]
[null,"Per year",{"$f":"'Calculations - Dataset'!B131","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!C131","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!D131","v":{"$error":"#VALUE!"}},null,"Per year",{"$f":"'Calculations - Dataset'!E131","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!F131","v":{"$error":"#VALUE!"}}]
[null,null,"Cumulative feed intake (kg)","Nitrogen intake (kg)","Phosphorus intake (kg)",null,null,"Nitrogen excreted (kg)","Phosphorus excreted    (kg)"]
[null,"Per animal place/year",{"$f":"'Calculations - Dataset'!B136","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!C136","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!D136","v":{"$error":"#VALUE!"}},null,"Per animal place/year",{"$f":"'Calculations - Dataset'!A122","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!B122","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Emission Levels"]
[null,null,"Per cycle (t)",null,"Per year (t)","kg per tonne liveweight"]
[null,"Nitrogen",{"$f":"H17","v":0},null,{"$f":"H18","v":{"$error":"#VALUE!"}},{"$f":"((C25*1000)/('Calculations - Dataset'!$B$155/1000))","v":{"$error":"#DIV/0!"}}]
[null,"Phosphorus",{"$f":"I17","v":0},null,{"$f":"I18","v":{"$error":"#VALUE!"}},{"$f":"((C26*1000)/('Calculations - Dataset'!$B$155/1000))","v":{"$error":"#DIV/0!"}}]

{"sheet":"References and assumptions log","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["References and assumptions log"]
[]
["Unique ID","Description with key details ","Location in workbook","Link to evidence","Date of last update","Initials","Methodology behind assumption","Assumptions","Any other comments","Reference or assumption"]
["Poultry 01","This table presents performance data on broilers form  ROSS308 produced by Aviagen",{"$f":"CELL(\"address\",'Calculations - Data tables'!B4)","v":"'[Broiler_Model draft_V3_Password protected.xlsm]Calculations - Data tables'!$B$4"},"RossxRoss308-BroilerPerformanceObjectives2022-EN.pdf (aviagen.com)",44977,"LR","This data has been used to pull out body weight and cumulative intake values for poultry.","The data is presented in grams per day.","Updated data tables from those previously used in the AIC models.","Reference"]
["Poultry 02","Nitrogen Conversion Factor",{"$f":"CELL(\"address\",'Calculations - Data tables'!B68)","v":"'[Broiler_Model draft_V3_Password protected.xlsm]Calculations - Data tables'!$B$68"},"FAO (N.D>) https://www.fao.org/3/y5022e/y5022e03.htm#:~:text=On%20the%20basis%20of%20early,nitrogen%20content%20into%20protein%20content.",44977,"LR","This factor is used to convert crude protein content of feed to nitrogen.","Does not consider specifics of individual feeds but is a standardised factor used within the industry.","None.","Reference"]
["Poultry 03","Effect of Phytase on intake and excretion of dry matter, phosphorus, and nitrogen ",{"$f":"CELL(\"address\",'Calculations - Data tables'!B76)","v":"'[Broiler_Model draft_V3_Password protected.xlsm]Calculations - Data tables'!$B$76"},"Assuena V. et al., (2009), Effect of Dietary Phytase Supplementation on the Performance, Bone Densitometry, and Phosphorus and Nitrogen Excretion of Broilers. ",44978,"LR","This data has been used to calculate the impact of including phytase in the diet on the excretion of phosphorus.","Previously referenced in the AIC Broiler model.","Data limitation - This data is taken from a South American paper, and the diet is based on corn and soybean, on only 38-42d old broilers in a full metabolism trial.","Reference"]
["Poultry 04","Phytase feed additives effect on nitrogen","None","None",44978,"LR","None","Within the model calculations nitrogen is not impacted by phytase, this is an assumption based on current literature. ","This can be updated in the model a link is found.","Assumption"]
["Poultry 05","N and P retention factors from a study on phytase feed addition","None","Assuena V. et al., (2009), Effect of Dietary Phytase Supplementation on the Performance, Bone Densitometry, and Phosphorus and Nitrogen Excretion of Broilers. ",44978,"LR","This data has been used to calculate the impact of including phytase in the diet on the excretion of phosphorus.","The N and P retention factors do not require editing by user - the factors used in this model are from Assuena et al. (2009). Control N and P retention values used within this model are also from this study.","This can be updated in the model a link is found.","Assumption"]
["Poultry 06","Liveweight data","None","None",44978,"LR","None","We have included weighted average and liveweight to the dataset page as these are not required to be updated by the input user.","None","Assumption"]
["Poultry 07","Broiler performance data","None","None",44978,"LR","None","Currently the broiler performance data is based on \"As Hatched\" data which means it is a combination of both sexes.","None","Assumption"]

{"sheet":"Calculations - Data tables","index":5,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
["Data tables holding background data"]
[]
["Table 1. Poultry cumulative feed intake"]
["Source: ","Poultry 01","ROSS 308"]
["This table presents performance data on broilers form  ROSS308 produced by Aviagen"]
[]
["Day","Weight (g)","Target adjusted weight (g)","Daily Gain (g)","Average Daily Gain (g)","Daily Intake (g)","Cumulative Intake (g)","FCR","Target adjusted FCR","FCR/7 Day Mort Adjusted Cum Feed "]
[0,0,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":0},null,null,null,null,null,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":0}]
[1,62,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":62},18,null,null,12,0.19600000000000001,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.19600000000000001},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":12.152000000000001}]
[2,81,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":81},19,null,16,28,0.35199999999999998,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.35199999999999998},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":28.511999999999997}]
[3,102,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":102},21,null,20,48,0.47599999999999998,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.47599999999999998},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":48.552}]
[4,125,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":125},23,null,24,72,0.57699999999999996,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.57699999999999996},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":72.125}]
[5,151,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":151},26,null,27,100,0.65800000000000003,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.65800000000000003},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":99.358000000000004}]
[6,181,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":181},29,null,31,131,0.72399999999999998,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.72399999999999998},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":131.04399999999998}]
[7,213,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":213},32,24,35,166,0.78,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.78},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":166.14000000000001}]
[8,249,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":249},36,26,39,206,0.82599999999999996,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.82599999999999996},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":205.67399999999998}]
[9,288,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":288},39,27,44,249,0.86499999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.86499999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":249.12}]
[10,330,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":330},42,29,48,297,0.9,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.9},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":297}]
[11,376,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":376},46,30,52,349,0.93,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.93},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":349.68}]
[12,425,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":425},49,32,57,406,0.95699999999999996,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.95699999999999996},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":406.72499999999997}]
[13,477,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":477},52,33,62,468,0.98199999999999998,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":0.98199999999999998},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":468.41399999999999}]
[14,533,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":533},56,35,67,535,1.0049999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.0049999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":535.66499999999996}]
[15,592,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":592},59,37,72,608,1.026,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.026},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":607.39200000000005}]
[16,655,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":655},62,38,77,685,1.0469999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.0469999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":685.78499999999997}]
[17,720,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":720},66,40,83,768,1.0660000000000001,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.0660000000000001},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":767.5200000000001}]
[18,789,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":789},69,41,88,856,1.0860000000000001,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.0860000000000001},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":856.85400000000004}]
[19,860,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":860},72,43,94,950,1.105,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.105},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":950.3}]
[20,935,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":935},74,45,100,1050,1.123,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.123},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":1050.0050000000001}]
[21,1012,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1012},77,46,105,1155,1.1419999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.1419999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":1155.704}]
[22,1092,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1092},80,48,111,1266,1.1599999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.1599999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":1266.7199999999998}]
[23,1174,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1174},82,49,117,1383,1.1779999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.1779999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":1382.972}]
[24,1258,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1258},85,51,122,1505,1.196,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.196},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":1504.568}]
[25,1345,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1345},87,52,128,1633,1.214,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.214},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":1632.83}]
[26,1434,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1434},89,53,134,1767,1.2330000000000001,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.2330000000000001},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":1768.1220000000001}]
[27,1524,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1524},91,55,139,1907,1.2509999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.2509999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":1906.5239999999999}]
[28,1616,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1616},92,56,145,2051,1.2689999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.2689999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":2050.7039999999997}]
[29,1710,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1710},94,57,150,2202,1.288,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.288},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":2202.48}]
[30,1805,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1805},95,59,156,2357,1.306,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.306},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":2357.33}]
[31,1901,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1901},96,60,161,2518,1.325,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.325},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":2518.8249999999998}]
[32,1999,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":1999},97,61,166,2684,1.343,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.343},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":2684.6570000000002}]
[33,2091,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2091},98,62,171,2855,1.3620000000000001,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.3620000000000001},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":2847.942}]
[34,2196,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2196},99,63,176,3031,1.381,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.381},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":3032.6759999999999}]
[35,2296,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2296},100,64,180,3211,1.399,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.399},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":3212.1040000000003}]
[36,2396,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2396},100,65,185,3396,1.4179999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.4179999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":3397.5279999999998}]
[37,2496,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2496},100,66,189,3584,1.4370000000000001,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.4370000000000001},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":3586.752}]
[38,2597,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2597},101,67,193,3777,1.456,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.456},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":3781.232}]
[39,2697,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2697},101,68,197,3974,1.474,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.474},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":3975.3780000000002}]
[40,2798,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2798},100,69,201,4175,1.4930000000000001,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.4930000000000001},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":4177.4140000000007}]
[41,2898,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2898},100,70,204,4379,1.512,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.512},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":4381.7759999999998}]
[42,2998,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":2998},100,70,207,4586,1.5309999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.5309999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":4589.9380000000001}]
[43,3097,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3097},100,71,211,4797,1.55,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.55},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":4800.3500000000004}]
[44,3197,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3197},99,72,213,5010,1.569,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.569},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":5016.0929999999998}]
[45,3295,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3295},98,72,216,5226,1.587,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.587},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":5229.165}]
[46,3393,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3393},98,73,219,5445,1.6060000000000001,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.6060000000000001},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":5449.1580000000004}]
[47,3490,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3490},97,73,221,5666,1.625,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.625},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":5671.25}]
[48,3586,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3586},96,74,223,5890,1.6439999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.6439999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":5895.384}]
[49,3681,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3681},95,74,225,6115,1.663,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.663},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":6121.5029999999997}]
[50,3776,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3776},94,75,227,6342,1.681,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.681},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":6347.4560000000001}]
[51,3869,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3869},93,75,229,6571,1.7,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.7},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":6577.3}]
[52,3961,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":3961},92,75,230,6801,1.7190000000000001,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.7190000000000001},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":6808.9590000000007}]
[53,4052,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":4052},91,76,231,7032,1.738,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.738},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":7042.3760000000002}]
[54,4142,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":4142},90,76,233,7265,1.756,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.756},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":7273.3519999999999}]
[55,4230,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":4230},89,76,233,7498,1.7749999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.7749999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":7508.25}]
[56,4318,{"$f":"Table2[[#This Row],[Weight (g)]]*Table18[% of Target bodyweight]","v":4318},87,76,234,7733,1.7929999999999999,{"$f":"Table2[[#This Row],[FCR]]*Table1820[% of Target bodyweight]","v":1.7929999999999999},{"$f":"IF('Flock input details'!$C$18>0,(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[Target adjusted FCR]]),(Table2[[#This Row],[Target adjusted weight (g)]]*Table2[[#This Row],[FCR]]))","v":7742.174}]
[]
[]
["Table 2. Protein/Nitrogen Conversion Factor"]
["Source: ","Poultry 02"]
["Factor to convert crude protein content to total nitrogen content. E.g. g protein in the feed per g N in the feed."]
[]
["Crude protein to nitrogen conversion factor:","Phosphorus to phosphate conversion factor"]
[6.25]
[]
[]
["Table 3. Effect of Phytase on intake and excretion of dry matter, phosphorus, and nitrogen "]
["Source: ","Poultry 03","Assuena (2009)"]
["Phytase feed additive intake impacts. One FTU is one phytase unit."]
[]
["Phytase amount","Dry matter intake (DMI)\n(g)","Phosphorus intake (PI)\n(g)","Nitrogen intake (NI)\n(g)","Dry matter excreta (DME)\n(g)","Phosphorus excreta (PE)\n(g)","Nitrogen excreta (NE)\n(g)"]
["Control",648,4.1399999999999997,20.65,173,3.06,10.98]
["250 FTU/kg",640,4.03,21.13,162,2.84,10.76]
["500 FTU/kg",659,3.89,20.45,182,2.7,11.82]
["750 FTU/kg",685,3.7,21.31,188,2.34,11.14]
["1000 FTU/kg",659,3.29,22.52,185,1.88,11.8]

{"sheet":"Calculations - Dataset","index":6,"n_rows":171,"n_cols":13,"rows_kept":171,"cut":false,"hidden":true,"merged":[]}
["Calculations"]
[]
["Table 1. Bodyweight and Cumulative feed intake"]
["Source: ","Poultry 01","ROSS308"]
["This table contains the assumed bodyweights and cumulative feed intake for the animals based on the ROSS308 performance objectives and the end day of each phase"]
[]
["Diet type","Bodyweight (g)","Cum. feed intake (g) ","FCR","Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)","Wholewheat intake (%)","Compound feed intake (%)","Wholewheat intake (g)","Compound feed intake (g)","Sum of feed (g)"]
[{"$f":"'Diet input details'!C6","v":"Editable entry cell"},{"$f":"VLOOKUP('Diet input details'!E20,Perf_Data,2)","v":0},{"$f":"VLOOKUP('Diet input details'!E20,Perf_Data,7)","v":0},{"$f":"VLOOKUP('Diet input details'!E20,Perf_Data,8)","v":0},{"$f":"VLOOKUP('Diet input details'!E20,Perf_Data,10)","v":0},{"$f":"'Diet input details'!F20","v":0},{"$f":"1-F8","v":1},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,F8*E8,0)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,G8*E8,0)","v":0},"N/A"]
[{"$f":"'Diet input details'!C7","v":"Editable entry cell"},{"$f":"VLOOKUP('Diet input details'!E21,Perf_Data,2)","v":0},{"$f":"VLOOKUP('Diet input details'!E21,Perf_Data,7)","v":0},{"$f":"VLOOKUP('Diet input details'!E21,Perf_Data,8)","v":0},{"$f":"VLOOKUP('Diet input details'!E21,Perf_Data,10)","v":0},{"$f":"'Diet input details'!F21","v":0},{"$f":"1-F9","v":1},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,F9*(E9-E8),0)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,G9*(E9-E8),0)","v":0},"N/A"]
[{"$f":"'Diet input details'!C8","v":"Editable entry cell"},{"$f":"VLOOKUP('Diet input details'!E22,Perf_Data,2)","v":0},{"$f":"VLOOKUP('Diet input details'!E22,Perf_Data,7)","v":0},{"$f":"VLOOKUP('Diet input details'!E22,Perf_Data,8)","v":0},{"$f":"VLOOKUP('Diet input details'!E22,Perf_Data,10)","v":0},{"$f":"'Diet input details'!F22","v":0},1,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,F10*(E10-E9),0)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,G10*(E10-E9),0)","v":0},"N/A"]
[{"$f":"'Diet input details'!C9","v":"Editable entry cell"},{"$f":"VLOOKUP('Diet input details'!E23,Perf_Data,2)","v":0},{"$f":"VLOOKUP('Diet input details'!E23,Perf_Data,7)","v":0},{"$f":"VLOOKUP('Diet input details'!E23,Perf_Data,8)","v":0},{"$f":"VLOOKUP('Diet input details'!E23,Perf_Data,10)","v":0},{"$f":"'Diet input details'!F23","v":0},1,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,F11*(E11-E10),0)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,G11*(E11-E10),0)","v":0},"N/A"]
[{"$f":"'Diet input details'!C10","v":"Editable entry cell"},{"$f":"VLOOKUP('Diet input details'!E24,Perf_Data,2)","v":0},{"$f":"VLOOKUP('Diet input details'!E24,Perf_Data,7)","v":0},{"$f":"VLOOKUP('Diet input details'!E24,Perf_Data,8)","v":0},{"$f":"VLOOKUP('Diet input details'!E24,Perf_Data,10)","v":0},{"$f":"'Diet input details'!F24","v":0},1,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,F12*(E12-E11),0)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,G12*(E12-E11),0)","v":0},"N/A"]
[{"$f":"'Diet input details'!C11","v":"Editable entry cell"},{"$f":"VLOOKUP('Diet input details'!E25,Perf_Data,2)","v":0},{"$f":"VLOOKUP('Diet input details'!E25,Perf_Data,7)","v":0},{"$f":"VLOOKUP('Diet input details'!E25,Perf_Data,8)","v":0},{"$f":"VLOOKUP('Diet input details'!E25,Perf_Data,10)","v":0},{"$f":"'Diet input details'!F25","v":0},1,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,F13*(E13-E12),0)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,G13*(E13-E12),0)","v":0},"N/A"]
[{"$f":"'Diet input details'!C12","v":"Editable entry cell"},{"$f":"VLOOKUP('Diet input details'!E26,Perf_Data,2)","v":0},{"$f":"VLOOKUP('Diet input details'!E26,Perf_Data,7)","v":0},{"$f":"VLOOKUP('Diet input details'!E26,Perf_Data,8)","v":0},{"$f":"VLOOKUP('Diet input details'!E26,Perf_Data,10)","v":0},{"$f":"'Diet input details'!F26","v":0},1,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,F14*(E14-E13),0)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,G14*(E14-E13),0)","v":0},"N/A"]
[{"$f":"'Diet input details'!C13","v":"Editable entry cell"},{"$f":"VLOOKUP('Diet input details'!E27,Perf_Data,2)","v":0},{"$f":"VLOOKUP('Diet input details'!E27,Perf_Data,7)","v":0},{"$f":"VLOOKUP('Diet input details'!E27,Perf_Data,8)","v":0},{"$f":"VLOOKUP('Diet input details'!E27,Perf_Data,10)","v":0},{"$f":"'Diet input details'!F27","v":0},1,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,F15*(E15-E14),0)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,G15*(E15-E14),0)","v":0},"N/A"]
[{"$f":"'Diet input details'!C14","v":"Editable entry cell"},{"$f":"VLOOKUP('Diet input details'!E28,Perf_Data,2)","v":0},{"$f":"VLOOKUP('Diet input details'!E28,Perf_Data,7)","v":0},{"$f":"VLOOKUP('Diet input details'!E28,Perf_Data,8)","v":0},{"$f":"VLOOKUP('Diet input details'!E28,Perf_Data,10)","v":0},{"$f":"'Diet input details'!F28","v":0},1,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,F16*(E16-E15),0)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum Feed Intake (g) (adjusted for FCR and 7 day mortality)]]>0,G16*(E16-E15),0)","v":0},"N/A"]
["Total",{"$f":"SUMIF(B8:B16,\"<>#N/A\")","v":0},{"$f":"SUMIF(C8:C16,\"<>#N/A\")","v":0},null,null,null,null,{"$f":"SUMIF(H8:H16,\"<>#N/A\")","v":0},{"$f":"SUMIF(I8:I16,\"<>#N/A\")","v":0},{"$f":"SUM(Table1_bw_feed_intake[[#This Row],[Wholewheat intake (g)]:[Compound feed intake (g)]])","v":0}]
[]
[]
["Table 2. N and P Intake"]
["Source: ","N/A"]
["This table contains the N and P intake at each phase based on the cumulative feed intake (Table 1 from 'Data tables'), and the nutrient status of the feed (from 'Diet input details')"]
[]
["Diet type","Feed Nitrogen conc. (%)","Feed Phosphorus conc. (%)","Wholewheat Nitrogen conc. (%) ","Wholewheat Phosphorus conc. (%)","Compound feed Nitrogen consumed (g)","Compound feed Phosphorus consumed (g)","Wholewheat Nitrogen consumed (g)","Wholewheat Phosphorus consumed (g)","Total Nitrogen consumed (g)","Total Phosphorus consumed (g)"]
[{"$f":"A8","v":"Editable entry cell"},{"$f":"'Diet input details'!E6","v":0},{"$f":"'Diet input details'!F6","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},{"$f":"B25%*I8","v":0},{"$f":"C25%*I8","v":0},{"$f":"D25%*H8","v":0},{"$f":"E25%*H8","v":0},{"$f":"F25+H25","v":0},{"$f":"G25+I25","v":0}]
[{"$f":"A9","v":"Editable entry cell"},{"$f":"'Diet input details'!E7","v":0},{"$f":"'Diet input details'!F7","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},{"$f":"B26%*I9","v":0},{"$f":"C26%*I9","v":0},{"$f":"D26%*H9","v":0},{"$f":"E26%*H9","v":0},{"$f":"F26+H26","v":0},{"$f":"G26+I26","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E8","v":0},{"$f":"'Diet input details'!F8","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},{"$f":"B27%*I10","v":0},0,0,0,0,{"$f":"G27+I27","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E9","v":0},{"$f":"'Diet input details'!F9","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},{"$f":"B28%*I11","v":0},{"$f":"C28%*I11","v":0},0,0,0,0]
["Editable entry cell",{"$f":"'Diet input details'!E10","v":0},{"$f":"'Diet input details'!F10","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},{"$f":"B29%*I12","v":0},0,{"$f":"D29%*H12","v":0},0,0,0]
["Editable entry cell",{"$f":"'Diet input details'!E11","v":0},{"$f":"'Diet input details'!F11","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,{"$f":"C30%*I13","v":0},0,0,0,0]
["Editable entry cell",{"$f":"'Diet input details'!E12","v":0},{"$f":"'Diet input details'!F12","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,0,0,0,0,0]
["Editable entry cell",{"$f":"'Diet input details'!E13","v":0},{"$f":"'Diet input details'!F13","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},{"$f":"B32%*I15","v":0},0,0,0,{"$f":"F32+H32","v":0},{"$f":"G32+I32","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E14","v":0},{"$f":"'Diet input details'!F14","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,{"$f":"C33%*I16","v":0},0,0,0,0]
["Total ",null,null,null,null,{"$f":"SUMIF(F25:F33,\"<>#N/A\")","v":0},{"$f":"SUMIF(G25:G33,\"<>#N/A\")","v":0},0,0,0,0]
[]
[]
["Table 3. Effect of Phytase"]
["Source: ","Poultry 03","Assuena (2009)"]
["This table shows how the effect of phytase has been calculated based on the data pulled from Assuena (2009), as well as the cumulative feed intake adjusted to account for this impact "]
[]
[]
["Phytase amount (FTU)","Dry Matter Intake(g)","Phosphorus Intake(g)","Nitrogen Intake(g)","Dry Matter Excreted(g)","Phosphorus Excreted(g)","Nitrogen Excreted(g)","Dry Matter Excretion Factor","Phosphorus Excretion Factor","Nitrogen Excretion Factor","Dry Matter Absorption Factor ","Phosphorus Absorption Factor","Nitrogen Absorption Factor"]
["None",648,4.1399999999999997,20.65,173,3.06,10.98,{"$f":"E43/B43","v":0.26697530864197533},{"$f":"F43/C43","v":0.73913043478260876},{"$f":"G43/D43","v":0.53171912832929791},{"$f":"1-H43","v":0.73302469135802473},{"$f":"1-I43","v":0.26086956521739124},{"$f":"1-J43","v":0.46828087167070209}]
["250 FTU/kg",640,4.03,21.13,162,2.84,10.76,{"$f":"E44/B44","v":0.25312499999999999},{"$f":"F44/C44","v":0.70471464019851104},{"$f":"G44/D44","v":0.50922858495030765},{"$f":"1-H44","v":0.74687499999999996},{"$f":"1-I44","v":0.29528535980148896},{"$f":"1-J44","v":0.49077141504969235}]
["500 FTU/kg",659,3.89,20.45,182,2.7,11.82,{"$f":"E45/B45","v":0.27617602427921095},0.6940874035989717,0.57799511002444992,0.72382397572078905,{"$f":"1-I45","v":0.3059125964010283},0.42200488997555008]
["750 FTU/kg",685,3.7,21.31,188,2.34,11.14,0.27445255474452557,0.63243243243243241,0.52275926794931959,0.72554744525547443,0.36756756756756759,0.47724073205068041]
["1000 FTU/kg",659,3.29,22.52,185,1.88,11.8,0.28072837632776937,0.5714285714285714,{"$f":"G47/D47","v":0.52397868561278871},0.71927162367223063,0.4285714285714286,0.47602131438721129]
[]
[]
["Table 4. Applying Phytase Effect "]
["Source: ","Poultry 03","Assuena (2009)/Table 3"]
["Presents the N and P retention factors that will be used from Table 3 above (from 'Dataset'). "]
[]
["Retention factor","Value"]
["P Retention Factor",{"$f":"VLOOKUP('Diet input details'!E32,'Calculations - Dataset'!A42:M47,12,FALSE)","v":0.26086956521739124}]
["N Retention Factor ",0.46828087167070198]
[]
[]
["Table 5. N and P Retained "]
["Source: ","Table 2/Table 4 from 'Dataset'"]
["This table shows the amount of N and P that is retained in the body weight of the animal "]
[]
["Diet type","Nitrogen retained (g)","Phosphorus retained (g)"]
[{"$f":"A8","v":"Editable entry cell"},{"$f":"J25*$B$56","v":0},{"$f":"K25*$B$55","v":0}]
[{"$f":"A9","v":"Editable entry cell"},{"$f":"J26*$B$56","v":0},0]
["Editable entry cell",0,0]
["Editable entry cell",0,0]
["Editable entry cell",0,{"$f":"K29*$B$55","v":0}]
["Editable entry cell",{"$f":"J30*$B$56","v":0},0]
["Editable entry cell",0,0]
["Editable entry cell",0,0]
["Editable entry cell",0,0]
[]
["Table 6. N and P excreted"]
["Source: ","Table 5 from 'Dataset'"]
["N and P ingested (Table 2 from 'Dataset') take away N and P retained (Table 4 from 'Dataset')"]
[]
["Diet type","Nitrogen excreted (g)","Phosphorus excreted (g)"]
[{"$f":"A8","v":"Editable entry cell"},{"$f":"J25-B64","v":0},{"$f":"K25-C64","v":0}]
[{"$f":"A9","v":"Editable entry cell"},0,0]
["Editable entry cell",0,0]
["Editable entry cell",0,0]
["Editable entry cell",0,0]
["Editable entry cell",0,0]
["Editable entry cell",0,0]
["Editable entry cell",{"$f":"J32-B71","v":0},{"$f":"K32-C71","v":0}]
["Editable entry cell",0,0]
[]
["Table 7. Thinning Values"]
["Source: ","Model 1 - flock or herd details' "]
["This table presents the thinning factors that can be used to adjust the excretion values from Table 5 (from 'Dataset')"]
[]
[null,"Thinning %"]
[null,{"$f":"'Flock input details'!E11","v":0}]
[null,{"$f":"'Flock input details'!E12","v":0}]
[null,{"$f":"'Flock input details'!E13","v":0}]
["100% check ",{"$f":"SUM(B94:B96)=100%","v":false}]
[]
[]
["Table 8. Thinned Excretion Values"]
["Source: ","Table 6/Table 7"]
["This table presents the N and P excretion from Table 6, adjusted to reflect the amount of birds thinned using the thinning value in Table 7 (from 'Dataset')"]
[]
["Diet type","Ration End Day","Thinning Factor","Nitrogen Excreted (g)","Phosphorus Excreted (g)","Thinned Nitrogen Excretion (g)","Thinned Phosphorus Excretion (g)"]
[{"$f":"A8","v":"Editable entry cell"},{"$f":"'Diet input details'!E20","v":0},{"$f":"IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$13,'Flock input details'!$E$13,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$11,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$12,('Calculations - Dataset'!$B$94+'Calculations - Dataset'!$B$95),'Calculations - Dataset'!$B$94),0))","v":0},{"$f":"B79","v":0},{"$f":"C79","v":0},{"$f":"Table8_thin_ex[[#This Row],[Nitrogen Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0},{"$f":"Table8_thin_ex[[#This Row],[Phosphorus Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0}]
[{"$f":"A9","v":"Editable entry cell"},{"$f":"'Diet input details'!E21","v":0},{"$f":"IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$13,'Flock input details'!$E$13,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$11,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$12,('Calculations - Dataset'!$B$94+'Calculations - Dataset'!$B$95),'Calculations - Dataset'!$B$94),0))","v":0},{"$f":"B80","v":0},0,{"$f":"Table8_thin_ex[[#This Row],[Nitrogen Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0},{"$f":"Table8_thin_ex[[#This Row],[Phosphorus Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E22","v":0},{"$f":"IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$13,'Flock input details'!$E$13,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$11,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$12,('Calculations - Dataset'!$B$94+'Calculations - Dataset'!$B$95),'Calculations - Dataset'!$B$94),0))","v":0},0,0,{"$f":"Table8_thin_ex[[#This Row],[Nitrogen Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0},{"$f":"Table8_thin_ex[[#This Row],[Phosphorus Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E23","v":0},{"$f":"IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$13,'Flock input details'!$E$13,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$11,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$12,('Calculations - Dataset'!$B$94+'Calculations - Dataset'!$B$95),'Calculations - Dataset'!$B$94),0))","v":0},0,0,{"$f":"Table8_thin_ex[[#This Row],[Nitrogen Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0},{"$f":"Table8_thin_ex[[#This Row],[Phosphorus Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E24","v":0},{"$f":"IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$13,'Flock input details'!$E$13,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$11,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$12,('Calculations - Dataset'!$B$94+'Calculations - Dataset'!$B$95),'Calculations - Dataset'!$B$94),0))","v":0},0,0,{"$f":"Table8_thin_ex[[#This Row],[Nitrogen Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0},{"$f":"Table8_thin_ex[[#This Row],[Phosphorus Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E25","v":0},{"$f":"IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$13,'Flock input details'!$E$13,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$11,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$12,('Calculations - Dataset'!$B$94+'Calculations - Dataset'!$B$95),'Calculations - Dataset'!$B$94),0))","v":0},0,0,{"$f":"Table8_thin_ex[[#This Row],[Nitrogen Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0},{"$f":"Table8_thin_ex[[#This Row],[Phosphorus Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E26","v":0},{"$f":"IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$13,'Flock input details'!$E$13,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$11,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$12,('Calculations - Dataset'!$B$94+'Calculations - Dataset'!$B$95),'Calculations - Dataset'!$B$94),0))","v":0},0,0,{"$f":"Table8_thin_ex[[#This Row],[Nitrogen Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0},{"$f":"Table8_thin_ex[[#This Row],[Phosphorus Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E27","v":0},{"$f":"IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$13,'Flock input details'!$E$13,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$11,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$12,('Calculations - Dataset'!$B$94+'Calculations - Dataset'!$B$95),'Calculations - Dataset'!$B$94),0))","v":0},0,0,{"$f":"Table8_thin_ex[[#This Row],[Nitrogen Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0},{"$f":"Table8_thin_ex[[#This Row],[Phosphorus Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0}]
["Editable entry cell",{"$f":"'Diet input details'!E28","v":0},{"$f":"IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$13,'Flock input details'!$E$13,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$11,IF(Table8_thin_ex[[#This Row],[Ration End Day]]>'Flock input details'!$C$12,('Calculations - Dataset'!$B$94+'Calculations - Dataset'!$B$95),'Calculations - Dataset'!$B$94),0))","v":0},0,0,{"$f":"Table8_thin_ex[[#This Row],[Nitrogen Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0},{"$f":"Table8_thin_ex[[#This Row],[Phosphorus Excreted (g)]]*(1-Table8_thin_ex[[#This Row],[Thinning Factor]])","v":0}]
["TOTAL",null,null,{"$f":"SUMIF(D105:D113,\"<>#N/A\")","v":0},{"$f":"SUMIF(E105:E113,\"<>#N/A\")","v":0},0,0]
[]
[]
["Table 9. Nutrient excretion (kg/animal place/year)"]
["Source: "]
["This table converts the excretion values presented in Table 8 from grams per bird to kg/animal place/year.  The total nutrient excreted (from Table 8 in 'Dataset') is multiplied by cycles per year (from 'Flock input details'), and then divided by 1000 to convert from g to kg"]
[]
["Nitrogen excretion (kg)","Phosphorus excretion (kg)"]
[{"$f":"(F114*'Flock input details'!C7)/1000","v":{"$error":"#VALUE!"}},{"$f":"(G114*'Flock input details'!C7)/1000","v":{"$error":"#VALUE!"}}]
[]
[]
["Table 10. Per cycle/Per year values "]
["Source: ","N/A"]
["This table presents the intake and excreted values on a per cycle and per year basis.  These values are based off what has been calculated in the tables above and the days input to 'Flock input details'"]
[]
["Per cycle/year","Feed Intake (t)","Nitrogen Intake (t)","Phosphorus Intake (t)","Nitrogen Excretion (t)","Phosphorus Excretion (t)"]
["Per cycle",{"$f":"(J17*'Flock input details'!C5)/1000000","v":0},{"$f":"(J34*'Flock input details'!C5)/1000000","v":0},{"$f":"(K34*'Flock input details'!C5)/1000000","v":0},{"$f":"(F114*'Flock input details'!C5)/1000000","v":0},{"$f":"(G114*'Flock input details'!C5)/1000000","v":0}]
["Per year",{"$f":"B130*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"C130*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"D130*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"E130*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"F130*'Flock input details'!C7","v":{"$error":"#VALUE!"}}]
[]
[]
[]
["Per cycle/year","Feed Intake (kg)","Nitrogen Intake (kg)","Phosphorus Intake (kg)","Nitrogen Excretion (kg)","Phosphorus Excretion (kg)"]
["Per animal place/per year",{"$f":"(J17*'Flock input details'!C7)/1000","v":{"$error":"#VALUE!"}},{"$f":"(J34*'Flock input details'!C7)/1000","v":{"$error":"#VALUE!"}},{"$f":"(K34*'Flock input details'!C7)/1000","v":{"$error":"#VALUE!"}},{"$f":"Table9_ex_pp_yr[Nitrogen excretion (kg)]","v":{"$error":"#VALUE!"}},{"$f":"Table9_ex_pp_yr[Phosphorus excretion (kg)]","v":{"$error":"#VALUE!"}}]
[]
[]
["Table 11. Weighted Avg. Bird Weight"]
["Source: ","N/A"]
["This calculates the  weighted average bird weight based on bodyweight from ROSS308, %  thinned, and days of age data"]
[]
["Thinning","Bodyweight after thins (g)","Bodyweight after mortality (g)","Bodyweight after chick mortality (g)"]
["1 thin",{"$f":"((VLOOKUP('Flock input details'!C11,Perf_Data,3,FALSE))*'Flock input details'!E11)+((VLOOKUP('Flock input details'!C13,Perf_Data,3,FALSE))*'Flock input details'!E13)","v":0},{"$f":"B144*(1-'Flock input details'!$C$23)","v":0},{"$f":"C144-($B$8*'Flock input details'!$C$23)","v":0}]
["2 thins",{"$f":"((VLOOKUP('Flock input details'!C11,Perf_Data,3,FALSE))*'Flock input details'!E11)+((VLOOKUP('Flock input details'!C12,Perf_Data,3,FALSE))*'Flock input details'!E12)+((VLOOKUP('Flock input details'!C13,Perf_Data,3,FALSE))*'Flock input details'!E13)","v":0},{"$f":"B145*(1-'Flock input details'!$C$23)","v":0},{"$f":"C145-($B$8*'Flock input details'!$C$23)","v":0}]
[]
[]
["Table 12. Liveweight Calcs"]
["Source: ","N/A"]
["This calculates the  weighted average bird weight based on bodyweight from ROSS308, %  thinned, and days of age data"]
[]
[]
["Weight group","kg"]
["Weighted Ave. Bird weight (kg)",{"$f":"(IF('Flock input details'!C12>0,'Calculations - Dataset'!D145,'Calculations - Dataset'!D144))/1000*Table18[% of Target bodyweight]","v":0}]
["Liveweight/Crop (kg)",{"$f":"B154*('Flock input details'!C5*(1-'Flock input details'!C23))","v":0}]
[]
[]
["Table 13. Bodyweight Adjustment"]
["Source: ","N/A"]
["This calculates the % of the target bodyweight that the average bird in the system is reaching at clear"]
[]
["% of Target bodyweight"]
[{"$f":"IF('Flock input details'!C19=0,1,('Flock input details'!C19/'Flock input details'!D19))","v":1}]
[]
[]
["Table 13. FCR Adjustment"]
["Source: ","N/A"]
["This calculates the % of the target bodyweight that the average bird in the system is reaching at clear"]
[]
["% of Target bodyweight"]
[{"$f":"IF('Flock input details'!C18=0,1,('Flock input details'!C18/'Flock input details'!D18))","v":1}]